Convert a text string into a number or date

To convert a text string into a number, you can use the following syntax with the Number function:

<number variable> = Number(<text>)

In combination with the Substring function, you could use the Number function to extract the number part of a text string to a number variable. For example:

the number at the end of the course code = Number(Substring(the course code, 4, 4))

If the course code was LAWS2001, this rule would infer the number at the end of the course code to be 2001.

To convert a text string into a date, you can use the following syntax with the Date function:

<date variable> = Date (<text>)

The text string in these functions can be either a value or a variable. If it is a value it must be in quotation marks (eg "2000-04-17").